﻿/* @(#)GSManufacturedBean.java    
 *
 * Project: BUS
 *
 * Modify Information:
 * =============================================================================
 *   Author       Date       Description
 *   ------------ ---------- ---------------------------------------------------
 *   Tuthmos Liu     2008-6-3    Downexcelbean
 *
 * Copyright Notice:
 * =============================================================================
 *    Copyright (c) 2001-2006 Beijing HiTRUST Technology Co., Ltd. 1808 Room, 
 *        Science & Technology Building, No. 9 South Street, Zhong Guan Cun, 
 *        Haidian District, Beijing ,100081, China All rights reserved.
 *
 *    This software is the confidential and proprietary information of
 *        Beijing HiTRUST Technology Co., Ltd. ("Confidential Information").
 *        You shall not disclose such Confidential Information and shall use it
 *        only in accordance with the terms of the license agreement you entered
 *        into with HiTRUST.
 *
 * Warning:
 * =============================================================================
 * 
 */
package com.hitrust.gs.bean;

import java.sql.ResultSet;
import java.sql.SQLException;

import com.hitrust.gs.service.GSBaseBean;

/**
 * 产品信息
 */
public class GSManufacturedBean implements GSBaseBean {
    /**
     * 产品编号
     */
    private String gs_manufacture_id;
    
    /**
     * 
     */
    private static final long serialVersionUID = 1L;
    /**
     * 集中编码
     */
    private String gs_concentricity;
    /**
     * 供应商自用编码
     */
    //private String gs_provider_use_id;

    /**
     * 产品名称
     */
    private String gs_manufacture_name;

    /**
     * 产品种类编号
     */
    private String gs_manufacture_category_id;

    /**
     * 产品品牌
     */
    private String gs_manufacture_brand;

    /**
     * 产品型号
     */
    private String gs_manufacture_type;

    /**
     * 产品规格
     */
    private String gs_manufacture_spec;

    /**
     * 产品单价
     */
    private double gs_manufacture_unitprice;

    /**
     * 数量单位
     */
    private String gs_quant_unit;

    /**
     * 质保期
     */
    private String gs_quality_assure_period;

    /**
     * 生产厂商名称
     */
    private String gs_manufacturer_name;

    /**
     * 产地
     */
    private String gs_make_area;

    /**
     * 供应商编号
     */
    private String gs_provider_id;
    private String gs_provider_name;

    /**
     * 适用机型
     */
    private String gs_adapt_machine_type;

    /**
     * 产品图片
     */
    private String gs_manufacture_images;

    /**
     * 最近调价时间
     */
    private String gs_recent_adjustprice_date;

    /**
     * 最近调价价格
     */
    private double gs_recent_adjusted_price;

    /**
     * 录入人员帐号
     */
    private String gs_recorder_id;

    /**
     * 产品录入时间
     */
    private String gs_manufacture_record_date;

    /**
     * 是否交易平台的产品
     */
    private String gs_is_tradeflat_manufacture;
    
    private String providerName;
    
    
    private String gs_MANUFACTURE_DESC;

    /**
     * 产品附加属性
     */
    private String gs_appender_property;

    /**
     * 备注
     */
    private String gs_remark;
    
    private String gs_validity;
    
    private String is_buy;
    
    private String gs_drawing_peice_code;
    
    private String gs_code_bak;
    /**
     * 买断、压库
     * */
    private String gs_balance_mode;
    /**
     * @return the gs_balance_mode
     */
    public String getGs_balance_mode() {
        return this.gs_balance_mode;
    }

    /**
     * @param aGs_balance_mode the gs_balance_mode to set
     */
    public void setGs_balance_mode(String aGs_balance_mode) {
        this.gs_balance_mode = aGs_balance_mode;
    }

    public String getGs_drawing_peice_code() {
		return gs_drawing_peice_code;
	}

	public void setGs_drawing_peice_code(String gs_drawing_peice_code) {
		this.gs_drawing_peice_code = gs_drawing_peice_code;
	}

	public String getGs_validity() {
		return gs_validity;
	}

	public void setGs_validity(String gs_validity) {
		this.gs_validity = gs_validity;
	}

	public String getGs_code_bak() {
		return gs_code_bak;
	}

	public void setGs_code_bak(String gs_code_bak) {
		this.gs_code_bak = gs_code_bak;
	}

	/**
     * 返回gs_adapt_machine_type.
     */
    public String getGs_adapt_machine_type() {
        return this.gs_adapt_machine_type;
    }

    /**
     * @param aGs_adapt_machine_type
     *            赋值给gs_adapt_machine_type.
     */
    public void setGs_adapt_machine_type(String aGs_adapt_machine_type) {
        this.gs_adapt_machine_type = aGs_adapt_machine_type;
    }

    /**
     * 返回gs_is_tradeflat_manufacture.
     */
    public String getGs_is_tradeflat_manufacture() {
        return this.gs_is_tradeflat_manufacture;
    }

    /**
     * @param aGs_is_tradeflat_manufacture
     *            赋值给gs_is_tradeflat_manufacture.
     */
    public void setGs_is_tradeflat_manufacture(
            String aGs_is_tradeflat_manufacture) {
        this.gs_is_tradeflat_manufacture = aGs_is_tradeflat_manufacture;
    }

    /**
     * 返回gs_make_area.
     */
    public String getGs_make_area() {
        return this.gs_make_area;
    }

    /**
     * @param aGs_make_area
     *            赋值给gs_make_area.
     */
    public void setGs_make_area(String aGs_make_area) {
        this.gs_make_area = aGs_make_area;
    }

    /**
     * 返回gs_manufacture_brand.
     */
    public String getGs_manufacture_brand() {
        return this.gs_manufacture_brand;
    }

    /**
     * @param aGs_manufacture_brand
     *            赋值给gs_manufacture_brand.
     */
    public void setGs_manufacture_brand(String aGs_manufacture_brand) {
        this.gs_manufacture_brand = aGs_manufacture_brand;
    }

    /**
     * 返回gs_manufacture_images.
     */
    public String getGs_manufacture_images() {
        return this.gs_manufacture_images;
    }

    /**
     * @param aGs_manufacture_images
     *            赋值给gs_manufacture_images.
     */
    public void setGs_manufacture_images(String aGs_manufacture_images) {
        this.gs_manufacture_images = aGs_manufacture_images;
    }

    /**
     * 返回gs_manufacture_name.
     */
    public String getGs_manufacture_name() {
        return this.gs_manufacture_name;
    }

    /**
     * @param aGs_manufacture_name
     *            赋值给gs_manufacture_name.
     */
    public void setGs_manufacture_name(String aGs_manufacture_name) {
        this.gs_manufacture_name = aGs_manufacture_name;
    }

    /**
     * 返回gs_manufacture_record_date.
     */
    public String getGs_manufacture_record_date() {
        return this.gs_manufacture_record_date;
    }

    /**
     * @param aGs_manufacture_record_date
     *            赋值给gs_manufacture_record_date.
     */
    public void setGs_manufacture_record_date(String aGs_manufacture_record_date) {
        this.gs_manufacture_record_date = aGs_manufacture_record_date;
    }

    /**
     * 返回gs_manufacture_spec.
     */
    public String getGs_manufacture_spec() {
        return this.gs_manufacture_spec;
    }

    /**
     * @param aGs_manufacture_spec
     *            赋值给gs_manufacture_spec.
     */
    public void setGs_manufacture_spec(String aGs_manufacture_spec) {
        this.gs_manufacture_spec = aGs_manufacture_spec;
    }

    /**
     * 返回gs_manufacture_type.
     */
    public String getGs_manufacture_type() {
        return this.gs_manufacture_type;
    }

    /**
     * @param aGs_manufacture_type
     *            赋值给gs_manufacture_type.
     */
    public void setGs_manufacture_type(String aGs_manufacture_type) {
        this.gs_manufacture_type = aGs_manufacture_type;
    }

    /**
     * 返回gs_manufacture_unitprice.
     */
    public double getGs_manufacture_unitprice() {
        return this.gs_manufacture_unitprice;
    }

    /**
     * @param aGs_manufacture_unitprice
     *            赋值给gs_manufacture_unitprice.
     */
    public void setGs_manufacture_unitprice(double aGs_manufacture_unitprice) {
        this.gs_manufacture_unitprice = aGs_manufacture_unitprice;
    }

    /**
     * 返回gs_manufacturer_name.
     */
    public String getGs_manufacturer_name() {
        return this.gs_manufacturer_name;
    }

    /**
     * @param aGs_manufacturer_name
     *            赋值给gs_manufacturer_name.
     */
    public void setGs_manufacturer_name(String aGs_manufacturer_name) {
        this.gs_manufacturer_name = aGs_manufacturer_name;
    }

    /**
     * 返回gs_provider_id.
     */
    public String getGs_provider_id() {
        return this.gs_provider_id;
    }

    /**
     * @param aGs_provider_id
     *            赋值给gs_provider_id.
     */
    public void setGs_provider_id(String aGs_provider_id) {
        this.gs_provider_id = aGs_provider_id;
    }

   

    /**
     * 返回gs_quality_assure_period.
     */
    public String getGs_quality_assure_period() {
        return this.gs_quality_assure_period;
    }

    /**
     * @param aGs_quality_assure_period
     *            赋值给gs_quality_assure_period.
     */
    public void setGs_quality_assure_period(String aGs_quality_assure_period) {
        this.gs_quality_assure_period = aGs_quality_assure_period;
    }

    /**
     * 返回gs_quant_unit.
     */
    public String getGs_quant_unit() {
        return this.gs_quant_unit;
    }

    /**
     * @param aGs_quant_unit
     *            赋值给gs_quant_unit.
     */
    public void setGs_quant_unit(String aGs_quant_unit) {
        this.gs_quant_unit = aGs_quant_unit;
    }

    /**
     * 返回gs_recent_adjusted_price.
     */
    public double getGs_recent_adjusted_price() {
        return this.gs_recent_adjusted_price;
    }

    /**
     * @param aGs_recent_adjusted_price
     *            赋值给gs_recent_adjusted_price.
     */
    public void setGs_recent_adjusted_price(double aGs_recent_adjusted_price) {
        this.gs_recent_adjusted_price = aGs_recent_adjusted_price;
    }

    /**
     * 返回gs_recent_adjustprice_date.
     */
    public String getGs_recent_adjustprice_date() {
        return this.gs_recent_adjustprice_date;
    }

    /**
     * @param aGs_recent_adjustprice_date
     *            赋值给gs_recent_adjustprice_date.
     */
    public void setGs_recent_adjustprice_date(String aGs_recent_adjustprice_date) {
        this.gs_recent_adjustprice_date = aGs_recent_adjustprice_date;
    }

    /**
     * 返回gs_recorder_id.
     */
    public String getGs_recorder_id() {
        return this.gs_recorder_id;
    }

    /**
     * @param aGs_recorder_id
     *            赋值给gs_recorder_id.
     */
    public void setGs_recorder_id(String aGs_recorder_id) {
        this.gs_recorder_id = aGs_recorder_id;
    }

    public Object process(ResultSet aResultSet) throws SQLException {
      GSManufacturedBean tGSManufacturedBean = new GSManufacturedBean();
        tGSManufacturedBean.gs_adapt_machine_type=aResultSet.getString("GS_ADAPT_MACHINE_TYPE")== null ? "" :aResultSet.getString("GS_ADAPT_MACHINE_TYPE").trim();
        tGSManufacturedBean.gs_is_tradeflat_manufacture=aResultSet.getString("GS_IS_TRADEFLAT_MANUFACTURE").trim();
        tGSManufacturedBean.gs_make_area=aResultSet.getString("GS_MAKE_AREA")== null ? "" :aResultSet.getString("GS_MAKE_AREA").trim();
        tGSManufacturedBean.gs_manufacture_brand=aResultSet.getString("GS_MANUFACTURE_BRAND") == null? "":aResultSet.getString("GS_MANUFACTURE_BRAND").trim();
        
        tGSManufacturedBean.gs_manufacture_category_id=aResultSet.getString("GS_MANUFACTURE_CATEGORY_ID")== null ? "" :aResultSet.getString("GS_MANUFACTURE_CATEGORY_ID").trim();
        
        tGSManufacturedBean.gs_concentricity=aResultSet.getString("GS_CONCENTRICITY_ID")==null?"":aResultSet.getString("GS_CONCENTRICITY_ID").trim();
        
        tGSManufacturedBean.gs_manufacture_images=aResultSet.getString("GS_MANUFACTURE_IMAGE")== null ? "" :aResultSet.getString("GS_MANUFACTURE_IMAGE").trim();
        
        tGSManufacturedBean.gs_manufacture_name=aResultSet.getString("GS_MANUFACTURE_NAME").trim();
        
        tGSManufacturedBean.gs_manufacture_record_date=aResultSet.getString("GS_MANUFACTURE_RECORD_DATE")==null? "":aResultSet.getString("GS_MANUFACTURE_RECORD_DATE").trim();
        tGSManufacturedBean.gs_manufacture_spec=aResultSet.getString("GS_MANUFACTURE_SPEC")== null ? "" :aResultSet.getString("GS_MANUFACTURE_SPEC").trim();
        tGSManufacturedBean.gs_manufacture_type=aResultSet.getString("GS_MANUFACTURE_TYPE")== null ? "" :aResultSet.getString("GS_MANUFACTURE_TYPE").trim();
        
        tGSManufacturedBean.gs_manufacture_unitprice=aResultSet.getDouble("GS_MANUFACTURE_UNITPRICE");
        
        tGSManufacturedBean.gs_manufacturer_name=aResultSet.getString("GS_MANUFACTURER_NAME")== null ? "" :aResultSet.getString("GS_MANUFACTURER_NAME").trim();
        
        tGSManufacturedBean.gs_provider_id=aResultSet.getString("GS_PROVIDER_ID");
       
        tGSManufacturedBean.gs_manufacture_id=aResultSet.getString("GS_MANUFACTURE_ID")== null ? "" :aResultSet.getString("GS_MANUFACTURE_ID").trim();
        tGSManufacturedBean.gs_quality_assure_period=aResultSet.getString("GS_QUALITY_ASSURE_PERIOD") == null? "":aResultSet.getString("GS_QUALITY_ASSURE_PERIOD").trim();
        tGSManufacturedBean.gs_quant_unit=aResultSet.getString("GS_QUANT_UNIT");
        tGSManufacturedBean.gs_recent_adjusted_price=aResultSet.getDouble("GS_RECENT_ADJUSTED_PRICE") ;
        tGSManufacturedBean.gs_recent_adjustprice_date=aResultSet.getString("GS_RECENT_ADJUSTPRICE_DATE")== null ? "" :aResultSet.getString("GS_RECENT_ADJUSTPRICE_DATE").trim();
        tGSManufacturedBean.gs_recorder_id=aResultSet.getString("GS_RECORDER_ID")== null ? "" :aResultSet.getString("GS_RECORDER_ID").trim();
        tGSManufacturedBean.gs_appender_property = aResultSet.getString("GS_APPENDER_PROPERTY") == null?"":aResultSet.getString("GS_APPENDER_PROPERTY").trim();
        tGSManufacturedBean.gs_remark = aResultSet.getString("GS_REMARK") == null? "":aResultSet.getString("GS_REMARK").trim();
        //added by simonyi 2006-9-29
        tGSManufacturedBean.gs_validity = aResultSet.getString("GS_VALIDITY") == null? "1":aResultSet.getString("GS_VALIDITY").trim();
        //added by simonyi 2006-3-14
		tGSManufacturedBean.is_buy = aResultSet.getString("IS_BUY") == null? "":aResultSet.getString("IS_BUY").trim();
		tGSManufacturedBean.gs_code_bak = aResultSet.getString("CODE_BAK") == null? "":aResultSet.getString("CODE_BAK").trim();
		tGSManufacturedBean.gs_MANUFACTURE_DESC= aResultSet.getString("GS_MANUFACTURE_DESC") == null? "":aResultSet.getString("GS_MANUFACTURE_DESC").trim();
		//2008-9-10		
		tGSManufacturedBean.gs_balance_mode=aResultSet.getString("gs_balance_mode") == null? "":aResultSet.getString("gs_balance_mode").trim();
		try{
            int index = aResultSet.findColumn("PROVIDERNAME");
            tGSManufacturedBean.providerName = aResultSet.getString(index);

            
        }catch(SQLException e){
            
        }
        //added by simonyi 2006-11-30
        try{
            int index = aResultSet.findColumn("GS_DRAWING_PIECE_CODE");
            tGSManufacturedBean.gs_drawing_peice_code = aResultSet.getString(index);

            
        }catch(SQLException e){
            
        }
        
      return tGSManufacturedBean;
    }

    /**
     * @return 返回 gs_concentricity.
     */
    public String getGs_concentricity() {
        return this.gs_concentricity;
    }

    /**
     * @param aGs_concentricity The gs_concentricity to set.
     */
    public void setGs_concentricity(String aGs_concentricity) {
        this.gs_concentricity = aGs_concentricity;
    }

    /**
     * @return 返回 gs_manufacture_id.
     */
    public String getGs_manufacture_id() {
        return this.gs_manufacture_id;
    }

    /**
     * @param aGs_manufacture_id The gs_manufacture_id to set.
     */
    public void setGs_manufacture_id(String aGs_manufacture_id) {
        this.gs_manufacture_id = aGs_manufacture_id;
    }

    /**
     * @return 返回 gs_manufacture_category_id.
     */
    public String getGs_manufacture_category_id() {
        return this.gs_manufacture_category_id;
    }

    /**
     * @param aGs_manufacture_category_id The gs_manufacture_category_id to set.
     */
    public void setGs_manufacture_category_id(String aGs_manufacture_category_id) {
        this.gs_manufacture_category_id = aGs_manufacture_category_id;
    }

    public String getGs_provider_name() {
        return gs_provider_name;
    }
    public void setGs_provider_name(String gs_provider_name) {
        this.gs_provider_name = gs_provider_name;
    }

    /**
     * @return 返回 gs_appender_property.
     */
    public String getGs_appender_property() {
        return this.gs_appender_property;
    }

    /**
     * @param aGs_appender_property The gs_appender_property to set.
     */
    public void setGs_appender_property(String aGs_appender_property) {
        this.gs_appender_property = aGs_appender_property;
    }

    /**
     * @return 返回 gs_remark.
     */
    public String getGs_remark() {
        return this.gs_remark;
    }

    /**
     * @param aGs_remark The gs_remark to set.
     */
    public void setGs_remark(String aGs_remark) {
        this.gs_remark = aGs_remark;
    }
    
    public String getProviderName() {
        return providerName;
    }
    
    public String getGs_manufacture_desc() {
        return gs_MANUFACTURE_DESC;
    }
    
    public void setGs_manufacture_desc(String gs_MANUFACTURE_DESC) {
        this.gs_MANUFACTURE_DESC = gs_MANUFACTURE_DESC;
    }
    
    
    public void setProviderName(String providerName) {
        this.providerName = providerName;
    }
    
	/**
	* @return 返回 is_buy.
	*/
	public String getIs_buy() {
		return this.is_buy;
	}

	/**
	* @param aIs_buy The is_buy to set.
	*/
	public void setIs_buy(String aIs_buy) {
		this.is_buy = aIs_buy;
	}
    
}
